<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="edu.sctu.User" %><%--
  Created by IntelliJ IDEA.
  User: dell
  Date: 2018/4/2
  Time: 19:55
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<style type="text/css">
    table{border-collapse: collapse;}
    td{border: 1px solid #000;
        padding: 10px;}
</style>
<!--include动作-->
<jsp:include page="header.jsp"></jsp:include>


<table>
    <tr>
        <td>编码</td>
        <td>姓名</td>
        <td>密码</td>
        <td>操作1</td>
        <td>操作2</td>
    </tr>

    <%
   //class User{
      // int id;
     // String name;
       // String password;

   // }
    List<User> userList=new ArrayList<User>();
   // User sun=new User();
   //sun.id=1;
 //sun.name="sunsiyu";
   //sun.password="123";
 // userList.add(sun);
  Connection connection=null;
    Statement statement=null;
    ResultSet resultset=null;
    String sql="select * from t_users";
    Class.forName("com.mysql.jdbc.Driver");
    connection= DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
            "root",
            "123456"
    );
    statement=connection.createStatement();
    resultset=statement.executeQuery(sql);
    while(resultset.next()){
        int id=resultset.getInt(1);
        String name=resultset.getString(2);
        String password=resultset.getString(3);
        User user=new User();
        user.setId(id);
        user.setName(name);
        user.setPassword(password);
userList.add(user);
    }
    resultset.close();
    statement.close();
    connection.close();
    pageContext.setAttribute("userList",userList);
    %>
    <c:forEach var="user" items="${userList}">
        <tr>
            <td>${user.id}</td>
            <td>${user.name}</td>
            <td>${user.password}</td>
            <td></td>
            <td></td>
        </tr>
    </c:forEach>

  <!-- for(User user:userList){
        out.write("<tr>"+"<td>"+user.id+"</td>"+"<td>"+user.name+"</td>"+"<td>"+user.password+"</td>" +
                "<td><a href='deleteUserHandler.jsp?id="+user.id+"'>删除</a></td>"+"<td><a href='userUpdate.jap?id="+user.id+"&username="+user.name+"&password="+user.password+"'>更新</a></td>" +
                "</tr>");
    }-->





</table>
<!--include指令-->
<%@include file="footer.jsp"%>
</body>
</html>
